Hi all,
Using DOORS, directly we can import excel file. I have many excel files (almost 500) which are similar in attribute types. Is there a way, i can put all the excel files in single folder and import into DOORS in single shot?
****************************************************************************
C:/Excel_Folder contains following:
File1.xlsx
File2.xlsx
File3.xlsx
File4.xlsx
.
.
.
.
File500.xlsx
All these excel sheet needs to be imported in one shot.
****************************************************************************
Elamkumaran - Fri Jan 25 05:11:59 EST 2013 |
Re: Import xlsx files from folder
Mathias Mamsch - Fri Jan 25 07:16:49 EST 2013
I guess, the quickest way to deal with this would be to make a VB macro to concatenate all .XLS sheets into one large sheet, before importing to DOORS. If you want to deal with this from DOORS, the following post shows you, how to automatize a GUI to run it in a loop on a set of files.
https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14585984�
If you need help, just post. Regards, Mathias
Mathias Mamsch, IT-QBase GmbH, Consultant for Requirement Engineering and D00RS
|